Step 1: Creating a Visual
1-
Double click or drag and drop a line and stacked
column chart.
2-
Enter Year and Month in the shared axis from
DateDim table.
3- Enter Border into the Column Series from the
Border Crossing table.
4- Enter Crossing PM in the Column Values from Key
Measures table.
5- Enter MoM% and YoY% into the Line Values from
Key Measures table.
6- Enter MoM% and YoY% into the Tooltips.
7- Format tab under visualization, expand General and set X Position 191, Y-Position 106, Width 495, and Height 306.
Step 1-1: Format the Visual:
1-
Expand X-axis and set Text size 10, turn off the
Title, and Turn on the Gridlines with Color #000000
2- Expand Y-axis and Color #000000, Text Size 10, Title off, Gridlines On, Line color #000000, Show secondary On, Align Zeros On, color #23BEC9, and Text size 12.
3- Data colors enter YoY% #12239E, MoM% #23BEC9, US-Canada Border #07AFF6, US-Mexico Border #63472B (Brown)
Step 1-2: Formatting the visual
1-
Turn On the Data Label, Color #2B9299, Value
Decimal Places 1, Position Inside Base, Text size 10, Background color # E6E6E6, Turn on Customize series, Drop down US-
Canada border Color #07AFF6, US-Mexico Border
#63472B, YoY% #12239E, MoM% #23BEC9, Text size 10,
2- Expand Shapes – turn on Shade area, Customize Series ON
3- Turn on Title – Write down the Title of the visual (By Crossing Border), font color #FFFFFF (white), Background color #70BBFF, Alignment Center and Text size 16.
4- Expand Background- Color # E6E6E6
5- Border On, Color # E6E6E6
How to create and format visual